<a href="special/rss/">RSS &raquo;</a>
<table width="100%" border="1">
  <tr><th>Page</th><th>Author</th><th>Time</th></tr>
<?php
// pagination?
$revisions = sqlite_fetch_all(sqlite_query($db,"SELECT * FROM revisions ORDER BY time DESC"));
// awkward hack, but necessary for the time being
for($i=0; $i<50; $i++) {
  $revision = $revisions[$i];
  $title = sqlite_fetch_single(sqlite_query($db,"SELECT name FROM pages WHERE id=".$revision['pageid']));
  echo "<tr>\n";
  echo "\t<td>".getLink("show",$title)."</td>\n";
  echo "\t<td>".$revision['author']."</td>\n";
  echo "\t<td>".date("g:ia - l, n/j/Y",$revision['time'])."</td>\n";
  echo "</tr>\n";
}
?>
</table>